Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL
1) Aggregate Functions
2) Analytical Functions
3) Char Functions
4) Constraints
5) Conversion Functions
6) Cursor
7) Data Type
8) Date Timezone
9) Hierarchical Query
10) Index
11) Insert Delete Update
12) Large Objects
13) Numeric Math Functions
14) Object Oriented Database
15) PL SQL
16) Regular Expressions
17) Report Column Page
18) Result Set
19) Select Query
20) Sequence
21) SQL Plus
22) Stored Procedure Function
23) Subquery
24) System Packages
25) System Tables Views
26) Table
27) Table Joins
28) Trigger
29) User Previliege
30) View
31) XML

User Previliege
1) Add the additional ALL clause to a GRANT statement in order to grant all possible privileges
2) Alter outline name
3) Alter outline to change the category
4) Alter user to change password
5) Alter user to change the password
6) Alter user to grant new quota value
7) Alter user to lock or unlock the account
8) Assign CONNECT and RESOURCE Roles
9) Assign Role to User
10) Change User password
11) Column-Level Object Privileges
12) Common System Privileges
13) Create a user and drop it
14) Create a user and grant the permission
15) Create a user and then drop it
16) Create a user, grant permission and alter its password
17) Create an outline
18) Create an outline and query user_outlines table
19) Create synonym for a view
20) Create synonym for table
21) Create synonyms for dropped tables
22) Create user
23) Create user and assign password
24) Create user chris identified by chris
25) Create User demo
26) Create user, grant permission and drop user
27) Creating a Private Synonym
28) Creating a profile with the time period for locking the account
29) Creating a Public Synonym
30) Creating a Role
31) Define a role as a global role, which means that a user can only be authorized to use the role by an enterprise directory
32) Directory privileges
33) Display current user
34) Drop public synonym
35) Drop Role
36) Drop synonym addresses
37) Drop the user if it exists
38) Get current user
39) Get current user name
40) Get two database users and show their roles
41) Get user name from all_users
42) Grant a system privilege to PUBLIC
43) Grant all on directory DirName to User
44) Grant create related permission
45) Grant CREATE SESSION privilege to a user, hr, allowing hr to log on to an Oracle database
46) GRANT CREATE SESSION TO newUserName in order to log in
47) Grant INSERT and UPDATE privileges at a column level
48) Grant one type or all types of privileges at once on any given object
49) Grant permission for a table to a user
50) Grant permission to system
51) Grant Permissions
52) Grant permissions and then check the dba_col_privs table
53) Grant Permissions to Role
54) Grant select on a table with synonym
55) Grant the CREATE TABLE privilege to DROPME
56) Grant update permission
57) Grant with user name and table name
58) If Tom owns a table Use the CASCADE keyword to drop it
59) Make a password expire with the ALTER USER command
60) Materialized view privileges
61) Output session roles from procedure
62) Procedure, function, and package privileges
63) Remove user
64) Revoke Permissions
65) Revoke Permissions with Cascade
66) REVOKE REFERENCES ON Employee FROM Bob
67) Revoking Object Privileges
68) Revoking roles
69) Select uid Current UID
70) Sequence privileges
71) Table privileges
72) Turning Auditing Off
73) Turning Auditing On in the Database
74) Unassign Role
75) Unassign Role from User
76) Unlock user
77) Use a password when a role is authorized by the database
78) Use current user name in where clause
79) Use schema in stored procedure
80) View privileges
81) Viewing synonyms and what they reference